未完成即submit_time是空的,这个是关键
其次做字段的更新,使用update即可
注意同时更新两个字段,需要用逗号隔开

update exam_record
set submit_time="2099-01-01 00:00:00",
score = 0
where start_time<"2021-09-01 00:00:00"
and submit_time is null