UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJigTcExKaOa+CtHflNhnruhORcT+yzvHsFjPwB89U4='
WHERE
key_id = 'f1c6f253a0079babd5fc46877316345b8cf2ca09015b79a94f41a18de7446a64'
AND (
token = 'zJigTcExKaOa+CtHflNhnruhORcT+yzvHsFjPwB89U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)