UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XkMbL94NZanjSMAH+P/y3zheUZLbAi79ixdYLLwIhOc='
WHERE
key_id = '997c947c1cdd06c79bfda4b5a93c2ac87d4cbe81880d6c28c9f32db741e6b1b1'
AND (
token = 'XkMbL94NZanjSMAH+P/y3zheUZLbAi79ixdYLLwIhOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)