It is a simple UPDATE --

UPDATEtblA

SET colA3 = colB1

FROM tblB

WHERE colA2 = colB2

AND colB3 = 1

;