UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gwkO688mn97EYL+u9J28FvXPYoE9Fq6ipqYVEMuOyb4=' 
WHERE 
  key_id = '2baae862dd5dc67ddc8872d89382a75805ac77748b4ff6ac0a30725cb8447b1e' 
  AND (
    token = 'gwkO688mn97EYL+u9J28FvXPYoE9Fq6ipqYVEMuOyb4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023