Use a procedure with both insert and update queries.
Check the TestProc
CREATE PROCEDURE TestProc
@Column1 varchar(50),
@Column2 varchar(50),
@Column3 varchar(50),
@Column4 varchar(50)
AS
BEGIN
insert into Table1(Column1, Column2) values (@Column1, @Column2)
update Table2 set Column4 = @Column4 where column3=@column3
END