UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZM2bYIRTYJVrEO6FE50T2qHCJRyeI/8It8wLxmrPFnk='
WHERE
key_id = '42552b9c276233a12738bd61117202f04e2746a908ff877394399244d0230a4d'
AND (
token = 'ZM2bYIRTYJVrEO6FE50T2qHCJRyeI/8It8wLxmrPFnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)