UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NLfN9A4afd9FTnUZKFuHcussrE9BylIWmiJqCIKPJmo='
WHERE
key_id = '6f6ff4689ceafb79c01020833daf0d15a92c1b8c8cca4e5aab8c03e0fe0e96b2'
AND (
token = 'NLfN9A4afd9FTnUZKFuHcussrE9BylIWmiJqCIKPJmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)