UPDATE table
SET name = temp1.name
FROM
( VALUES ( 'a4862df5d1f94d5db0ddd369dbf02fdd', 'new1' ), ( '66e82373db3844808478c98de7f5cde4', 'new2' ), ( 'fd52ee67c3f0494595340d8fb68016be', 'new6' ) ) AS temp1 ( c_bh, name )
WHERE
table.c_bh = temp1.c_bh;