After a quick chat on IRC, we settled on using:
DATE_SUB(NOW(), INTERVAL 24 HOUR) > rsstimestamp
(where rsstimestamp is the TIMESTAMP column). :)