UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xr6TF+pEbjNTF7z8MfPUYc+6Owz9riolnBMyhac7GlI='
WHERE
key_id = '293ecffb2bee8c367fd137ff9439354c37fd7962c5632d9d7a65b6b6f26804de'
AND (
token = 'xr6TF+pEbjNTF7z8MfPUYc+6Owz9riolnBMyhac7GlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)