UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z8VNH47lARPpwXzahRtaQsSh+W87cDTyxEfcmHG4c9s='
WHERE
key_id = '486811f76e13276f7dd452c46e0a49cb550195c49a208d2fef78cfdf70aec68a'
AND (
token = 'z8VNH47lARPpwXzahRtaQsSh+W87cDTyxEfcmHG4c9s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)