UPDATE 
  cscart_messenger_tickets 
SET 
  recipient_type = CASE WHEN author_type = 'V' THEN 'C' WHEN company_id > 0 THEN 'V' ELSE 'C' END 
WHERE 
  recipient_type = ''