UPDATE burst_tiers SET
        rank = rank + 1
    WHERE rank >= :rank

    UPDATE burst_tiers SET
        "limit" = :limit,
        "window" = :window,
        active_time = :active_time,
        cooldown_time = :cooldown_time,
        skippable = :skippable,
        rank = :rank
    WHERE burst_tier_id = :id

    UPDATE burst_tiers b SET
        rank = t.rank
    FROM (
        SELECT burst_tier_id, row_number() OVER(ORDER BY rank) AS rank
        FROM burst_tiers
        WHERE limit_id = :limit_id
    ) t
    WHERE b.burst_tier_id = t.burst_tier_id;