MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `clas` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `term` SMALLINT(4) UNSIGNED NOT NULL,
    `subject` VARCHAR(10) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_520_ci',
    `catalog` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
    `component` VARCHAR(10) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_520_ci',
    `section` VARCHAR(5) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_520_ci',
    PRIMARY KEY (`id`)
)
COLLATE='utf8mb4_unicode_520_ci'
ENGINE=InnoDB
;

CREATE TABLE `clas_import` (
    `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `term` SMALLINT(4) UNSIGNED NOT NULL,
    `subject` VARCHAR(10) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_520_ci',
    `catalog` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
    `component` VARCHAR(10) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_520_ci',
    `section` VARCHAR(5) NOT NULL DEFAULT '0' COLLATE 'utf8mb4_unicode_520_ci',
    PRIMARY KEY (`id`)
)
COLLATE='utf8mb4_unicode_520_ci'
ENGINE=InnoDB
;
INSERT INTO clas
  (`id`, `term`, `subject`, `catalog`, `component`, `section`)
VALUES
  ('23', '1730', 'ENG', '102', 'LEC', '1A04'),
  ('26', '1730', 'BLA', '102', 'LEC', '1A04'),
  ('30', '1730', 'ENG', '100', 'LEC', '1A04'),
  ('11', '1700', 'ENG', '102', 'LEC', '1A04');

INSERT INTO clas_import
  (`id`, `term`, `subject`, `catalog`, `component`, `section`)
VALUES
  ('1', '1730', 'ENG', '102', 'LEC', '1A04'),
  ('15', '1730', 'BLA', '102', 'LEC', '1A04');
SELECT * FROM clas


id
term
subject
catalog
component
section


11
1700
ENG
102
LEC
1A04

23
1730
ENG
102
LEC
1A04

26
1730
BLA
102
LEC
1A04

30
1730
ENG
100
LEC
1A04


SELECT * FROM clas_import


id
term
subject
catalog
component
section


1
1730
ENG
102
LEC
1A04

15
1730
BLA
102
LEC
1A04


DELETE
    FROM `clas`
WHERE
    `clas`.`term` IN (1730) AND
    EXISTS(
        SELECT
            1
        FROM
            `clas_import` as `ci`
        WHERE
            `clas`.`term`      = `ci`.`term` AND
            `clas`.`subject`   = `ci`.`subject` AND
            `clas`.`catalog`   = `ci`.`catalog` AND
            `clas`.`component` = `ci`.`component` AND
            `clas`.`section`   = `ci`.`section`
        )
select * from clas;


id
term
subject
catalog
component
section


11
1700
ENG
102
LEC
1A04

30
1730
ENG
100
LEC
1A04
id	term	subject	catalog	component	section
11	1700	ENG	102	LEC	1A04
23	1730	ENG	102	LEC	1A04
26	1730	BLA	102	LEC	1A04
30	1730	ENG	100	LEC	1A04