UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZlMdJ7AFXGLWpVjhD5mx1jMFlGXzaCYzUjEYy04nCE4='
WHERE
key_id = '726d08bf2da996295af2eb4300d5cc40ba6f93996f6cec3530fb24acecbdfd80'
AND (
token = 'ZlMdJ7AFXGLWpVjhD5mx1jMFlGXzaCYzUjEYy04nCE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)