How to MySQL database query filter by time

How can I filter my database query by a timestamp? So that for example only the last 24h are queried.
My query currently looks like this:
image
and my database:
image
ts = the timestamp