Most people just store the time as a time() value in a number field, which makes things real simple (assuming you don't care about daylight savings and so on). Though if you use the mySQL date/time types, you can also do something like (untested):

DELETE FROM tablename WHERE UNIX_TIMESTAMP(fieldname) < NOW() - 86400