UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pe8IJmFV2UJIi4Ex1eGiWoxIP6zFbNS9sC7ZLIFY2pM='
WHERE
key_id = '4ed30abb1a50b10f78ceb5688f37743171a3bacab9b76c1eaee7be254abcb294'
AND (
token = 'Pe8IJmFV2UJIi4Ex1eGiWoxIP6zFbNS9sC7ZLIFY2pM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)