UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CZNIWmvNzW+u2qjLn1JITPIa2w7elA6meBTP0bOrtIA='
WHERE
key_id = '65fc1aec0fa718d3d45a4c193a4fb0b5cbaffc9a035cd701125f0805e2d3fd51'
AND (
token = 'CZNIWmvNzW+u2qjLn1JITPIa2w7elA6meBTP0bOrtIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)