UPDATE table1 SET column_a IS NULL WHERE column_b = 'XXX';
UPDATE table1 SET column_a = NULL WHERE column_b = 'XXX';