SELECT 
  1 
FROM 
  tmall_lock_keys 
WHERE 
  key_id = '88cd12808de3ab567fe1f8518676fdd9e410d51ab650057112926171e25eecfc' 
  AND token = 'BMxx9TRaj5t+VWQmhA4CWbVBE6cd+9rWSs5OpRceEqo=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00746

JSON explain

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