UPDATE
table_name AS me
SET
me.status = 1
WHERE me.employeeId = 52787
AND me.status = 0
AND me.id >
(SELECT
temp.id
FROM
(SELECT
@rownum := @rownum + 1 AS rownum,
id
FROM
table_name m_e,
(SELECT
(@rownum := 0)) b
WHERE m_e.status = 0
ORDER BY id DESC) AS temp
WHERE temp.rownum = 1)
SELECT
temp.id
FROM
(SELECT
@rownum := @rownum + 1 AS rownum,
id
FROM
table_name,
(SELECT
(@rowNum := 0)) b
ORDER BY id DESC) AS temp
WHERE temp.rownum = 3;
table_name AS me
SET
me.status = 1
WHERE me.employeeId = 52787
AND me.status = 0
AND me.id >
(SELECT
temp.id
FROM
(SELECT
@rownum := @rownum + 1 AS rownum,
id
FROM
table_name m_e,
(SELECT
(@rownum := 0)) b
WHERE m_e.status = 0
ORDER BY id DESC) AS temp
WHERE temp.rownum = 1)
SELECT
temp.id
FROM
(SELECT
@rownum := @rownum + 1 AS rownum,
id
FROM
table_name,
(SELECT
(@rowNum := 0)) b
ORDER BY id DESC) AS temp
WHERE temp.rownum = 3;