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

Query time 0.00042