Duplicate key error for composite primary key when running update query without having duplicate
You have a primary key on the following fields, meaning that when combined they must be unique. 

PRIMARY KEY (entity_type,entity_id,deleted,language)

Currently, they are unique because you have two entries in the table for language. After your update, language would have the same entry for both rows, and the rows would no longer be unique.