UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7tLwWH3V5NhRoFnVJ4MqicdO6GJQ9pDOSlJiDYY5IUQ='
WHERE
key_id = 'fb5cc739f27b800a1cba000a97f0691e4a7ce6ae6062ac4ffe29425792d7c30c'
AND (
token = '7tLwWH3V5NhRoFnVJ4MqicdO6GJQ9pDOSlJiDYY5IUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)