Locking MySQL Select Row Until UPDATE Has Been Ran On It?

Understanding SQL Ordering with Python and SQLite: Best Practices for Retrieving Ordered Data from Unordered Tables

How to Sort Data by Two Columns with Opposite Directions in SQLite