Off the top of my head (untested), how about something like this:
UPDATE: This did not work
Code:
UPDATE xcart_products p
SET (title_tag, meta_keywords, meta_description) = (
SELECT product, product, product
FROM xcart_products_lng_en pl
WHERE pl.productid = p.productid
);