update movies
    SET name = 'example'
    where id = (select MAX(id) from movies);

update movies
    set name = 'example'
    order by id desc
    limit 1;