UPDATE scores AS SC
SET
    score = CASE WHEN score < 95 THEN score+5 ELSE 100 END
FROM
    students as ST
WHERE
    SC.student_code = ST.student_code
    AND
    ST.student_name IN ('佐藤 幸平', '山田 康介');