SELECT 
  1 
FROM 
  tmall_lock_keys 
WHERE 
  key_id = '828824d50e38a8698d4fd9510805ea047b68dfcd125fb5d83137cc49338c996c' 
  AND token = '1NiOm2lNq1/PVgLWabMF+zQ0326facGoZyUaO1pv8+U=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00763

JSON explain

{
  "query_block": {
    "select_id": 1,
    "table": {
      "message": "Impossible WHERE noticed after reading const tables"
    }
  }
}