UPDATE customer SET activestatus='0' WHERE DATEDIFF(expirydate,NOW())<1