UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jTrY8EM5n2zaKEkhRCGlcZcYCP6KGEOXsvHgQOMsbnw='
WHERE
key_id = '6f71dee39530c042aa49c3f26e51f5fb533c3d4386c121dfb0eaa2f5dcc16c65'
AND (
token = 'jTrY8EM5n2zaKEkhRCGlcZcYCP6KGEOXsvHgQOMsbnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)