UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VabCf0jR0Epj5s0apjWFHoOShUuBS4qGeMayj9Ps40E='
WHERE
key_id = 'eedee08473cbf741a78b6f7b4897121510fd59be95b8c6d4e3613f0259dcccdc'
AND (
token = 'VabCf0jR0Epj5s0apjWFHoOShUuBS4qGeMayj9Ps40E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)