我需要在下面的mssql代码转换为mysql的帮助。当我试图转换使用一些工具，它没有正确地转换。上有错误 ORDER BY Created OFFSET 1 ROWS FETCH NEXT 1 ROWS 部分。请帮我解决这个问题

UPDATE A
    SET A.Status = ISNULL(  (SELECT Status_new FROM MyTable B 
                            WHERE B.[Key] = A.[Key] 
                            ORDER BY Created OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY)
                        ,A.Status)
    FROM MyTable A
    WHERE Status_new IS NULL