Maybe something like this instead (untested):
UPDATE: This did not work (probably would for MSSQL)
Code:
UPDATE xcart_products p
SET
title_tag = pl.product,
meta_keywords = pl.product,
meta_description = pl.product
FROM xcart_products_lng_en pl
WHERE pl.productid = p.productid
);