You achieve like this:
you can use a transaction two make sure that two UPDATE statements are treated correct.
BEGIN TRANSACTION
UPDATE FirstTable
SET FirstTable.col1= 'XXXX'
FROM FirstTable T1, SecondTable T2
WHERE T1.id = T2.id
and T1.id = '010008'
UPDATE SecondTable
SET SecondTable.col1 = 'XXXX'
FROM FirstTable T1, SecondTable T2
WHERE T1.id = T2.id
and T1.id = '010008'
COMMIT