UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YX9t7FJQckIpUVDLBVobyXOjCli4FkabQ091gnZ9mY4='
WHERE
key_id = '4ffe77ecee49cae9f681e33dfb607f05201f810f8670a96bdff61b791a7ed97e'
AND (
token = 'YX9t7FJQckIpUVDLBVobyXOjCli4FkabQ091gnZ9mY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)