UPDATE TableA a
JOIN TableB b ON b.Column0 = a.Column0
SET
    a.Column1 = b.Column2, -- Original value: "DEF"
    b.Column2 = 'XYZ'
WHERE a.Column0 = 123;

SELECT Column1 FROM TableA WHERE Column0 = 123; -- DEF or XYZ?