UPDATE scores AS sc
SET score =case WHEN score+5<=100 THEN score+5 ELSE 100 END
FROM students AS st
WHERE sc.student_code=st.student_code
 AND st.student_name IN('佐藤 幸平','山田 康介');
 
 SELECT * FROM scores;