UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wXCtKZtjeR96oG2BrfqkPlxmNprmG17shF+hRh16Zuo=' 
WHERE 
  key_id = '80be49b6228e5dc8495d5a4d8ec38c5386f7b15d77449fb0f8573ab8ed1e005e' 
  AND (
    token = 'wXCtKZtjeR96oG2BrfqkPlxmNprmG17shF+hRh16Zuo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022