UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '49AOdlhD8ind0DMrfyNQ2fLKBJLxQSxdoY4i1wtGGro='
WHERE
key_id = 'bb1a9527b18ff5ee9aa71e421ac5b02ab3778c74b541fd0eb6f242a4216573e5'
AND (
token = '49AOdlhD8ind0DMrfyNQ2fLKBJLxQSxdoY4i1wtGGro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)