update warranty set status='expired' where date_expire is not null and date_expire < now() - interval 1 day;