UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c4r7J06NceEL4D7E+e5GkaAPSW9/QNaA4w+XSj5Uivg='
WHERE
key_id = '838a700c7e81bc3a3e04a4e509812ed8c4f6f88efaef4bff3026afe7bd2cfca1'
AND (
token = 'c4r7J06NceEL4D7E+e5GkaAPSW9/QNaA4w+XSj5Uivg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)