MemSQL supports SELECT FOR UPDATE but not SKIP LOCKED and NOWAIT.
You should be able to achieve what you want by updating a field on the row to mark it as logically locked or logically owned for a specific consuming application process. It sounds like that is what you are doing with the “Status” column you mentioned. Alternatively, you could include filters on the query to limit consumption to exclusive ranges of data based on some other criteria.
MemSQL in-memory row store updates are very fast, so these options should be viable.