my $expiration_seconds = 500; $dbh->prepare("SELECT * FROM message WHERE for_user=0 AND unix_timestamp(now())-unix_timestamp(tstamp) < $expiration_seconds ORDER BY tstamp");