UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GXAVaL4VsLX4vBhvjX99O9VHeWPW6hrvaw1wQKs7JOA='
WHERE
key_id = 'a69bfebc22156a24ba0796ce2f007cf3fa5edfe4cd85569c38d098109149467f'
AND (
token = 'GXAVaL4VsLX4vBhvjX99O9VHeWPW6hrvaw1wQKs7JOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)