mysql update items under safe update

DELETE FROM instances
WHERE instance_id IN (
  SELECT instance_id FROM (
    SELECT instance_id FROM instances
    WHERE name IN ('character_A', 'character_B')
  ) AS safe_subquery
);

UPDATE instances
SET shot = LPAD(SUBSTRING_INDEX(shot, '.', 1), 3, '0')
WHERE shot LIKE '%.0'
  AND instance_id IN (
    SELECT instance_id FROM (
      SELECT instance_id FROM instances
      WHERE shot LIKE '%.0'
    ) AS safe_subquery
  );