UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ABhL+bnngijrS8fEOVCXGvQNjG4fkNNQyHm/YgmXUI0='
WHERE
key_id = '9ca9098b5f0d55163d2a4faf2b1c1f69afc4fd8b407121e374459832c2d7f7b8'
AND (
token = 'ABhL+bnngijrS8fEOVCXGvQNjG4fkNNQyHm/YgmXUI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)