使用select语句在linkedserver表上执行更新

I'm trying to execute an update on a table that is on a linked server, with informations from a table on my current server and the query was taking something arround 2 hours to update a single test row, here is my queryI'm trying to execute an update on a table that