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

update movies m join
       (select max(m2.id) from movies m2) m2
       on m2.max_id = m.id
    set m.name = 'example';

select MAX(id) id from movies

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