UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVUwUVFoo9kXAaw3x5w/BWt0yg6fj8xNM7/FoshYllc='
WHERE
key_id = '5bcb7bedcb7a9e0dfa6af57a7b8eac34da50ac40613516010dfa42b584082909'
AND (
token = 'NVUwUVFoo9kXAaw3x5w/BWt0yg6fj8xNM7/FoshYllc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)