Sql query to select from 1 hour ago?

Use:

DELETE FROM wp_posts
 WHERE post_date < DATE_SUB(NOW(), INTERVAL '1' HOUR)
   AND post_status="publish"

Reference:

• DATE_ADD
• DATE_SUB