SELECT * FROM YOURTABLE WHERE YOURCOL < UNIX_TIMESTAMP() - 24 * 3600;