SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '55710675ecc84004f426f68acf2af4a644a678768e215ddaaf6810f72467464b' 
  AND token = '5FNvmlN/0rqS27GzK0ZxMqrlqaXk1m/mGKhuXILSEQw=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00034

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}