UPDATE avatars AS a SET
    job_rank = new.job_rank,
    job_name = new.job_name
FROM (VALUES
    (1, 10, 'explosion expert'),
    (2, 1, 'kuzuma')
) AS new(job_type_id, job_rank, job_name)
WHERE new.job_type_id = a.job_type_id;