SELECT 
  1 
FROM 
  tmall_lock_keys 
WHERE 
  key_id = 'e4ed6ed00e3bad77f3456796bfc0966252f1bb142aeeb5e9adfa0bb8b8f9fe49' 
  AND token = 'sazOG8i5Rll12IPH0NJA/n4Zu9peR0Y4p+YPIaZ9vE0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00824

JSON explain

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