I want to reset a column of the table after a month
Try using a transaction,

BEGIN;
  INSERT INTO t2
    SELECT *
    FROM t1
    WHERE status=0
    FOR UPDATE;

  DELETE FROM t1
    WHERE status=0;

COMMIT;