UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ThZhVUzpFwmXI+uprWnA4iz6SAG1atLHPj0RTW9eizU='
WHERE
key_id = '71c0cda99dc17e6aca1fe7f8d43b67f096c45c6a19e6764a9b4afe00525ce776'
AND (
token = 'ThZhVUzpFwmXI+uprWnA4iz6SAG1atLHPj0RTW9eizU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)