UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8nU3pSxLf70vjFeWefC52tLerQL0ldOFSSphUyzcTj4=' 
WHERE 
  key_id = 'de4c588951fd3dac861367e093789e9ca7b8ece63e9871ec232de79ba5f95b80' 
  AND (
    token = '8nU3pSxLf70vjFeWefC52tLerQL0ldOFSSphUyzcTj4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031