You need to put single quotes around non-numeric values like the special abilities line. It's a text field, since it contains commas and carets and multiple numbers, as opposed to a single numeric value like a number column.
Code:
UPDATE `npc_types` SET `special_abilities` = `special_abilities` + '2,1,25,8000,60000^3,1,15,1,75^5,4,100,0,0,0,100,0^ 7,1^9,1^10,1^38,1^41,1^44,1,0,5,15,5,20';