UPDATE `table1`
INNER JOIN table2
ON table2.Id =`table1`.table2Id
SET `table1`.name=table2.name
WHERE `table1`.age != '12' and `table1`.age != '31'
INNER JOIN table2
ON table2.Id =`table1`.table2Id
SET `table1`.name=table2.name
WHERE `table1`.age != '12' and `table1`.age != '31'