MySQL 5.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE elbat1
             (id integer,
              name varchar(64),
              folder varchar(64),
              subfolder varchar(64),
              count1 integer,
              count2 integer);
CREATE TABLE elbat2
             (id integer,
              name varchar(64),
              folder varchar(64),
              subfolder varchar(64),
              count1 integer,
              count2 integer);
INSERT INTO elbat1
            (id,
             name,
             folder,
             subfolder,
             count1,
             count2)
            VALUES (1,
                    'A',
                    'New',
                    'Car',
                    0,
                    0),
                   (2,
                    'B',
                    'Old',
                    'MC',
                    0,
                    0),
                   (3,
                    'C',
                    'Brand',
                    'Cycle',
                    0,
                    0);
INSERT INTO elbat2
            (id,
             name,
             folder,
             subfolder,
             count1,
             count2)
            VALUES (1,
                    'A',
                    'New',
                    'Car',
                    3,
                    5),
                   (2,
                    'B',
                    'Old',
                    'MC',
                    6,
                    8),
                   (3,
                    'C',
                    'Brand',
                    'Cycle',
                    4,
                    8);
SELECT *
       FROM elbat1;


id
name
folder
subfolder
count1
count2


1
A
New
Car
0
0

2
B
Old
MC
0
0

3
C
Brand
Cycle
0
0


SELECT *
       FROM elbat2;


id
name
folder
subfolder
count1
count2


1
A
New
Car
3
5

2
B
Old
MC
6
8

3
C
Brand
Cycle
4
8


UPDATE elbat1
       INNER JOIN elbat2
                  ON elbat2.name = elbat1.name
                     AND elbat2.folder = elbat1.folder
                     AND elbat2.subfolder = elbat1.subfolder
       SET elbat1.count1 = elbat2.count1,
           elbat1.count2 = elbat2.count2;
SELECT *
       FROM elbat1;


id
name
folder
subfolder
count1
count2


1
A
New
Car
3
5

2
B
Old
MC
6
8

3
C
Brand
Cycle
4
8


SELECT *
       FROM elbat2;


id
name
folder
subfolder
count1
count2


1
A
New
Car
3
5

2
B
Old
MC
6
8

3
C
Brand
Cycle
4
8