SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '413b7e948d892d5035a6ce9c70a10e794045efe1b5db75da10dad1607fe6a1f6' 
  AND token = 'd0DD28Y1fvcXnFaX8E/1U0w7f8Zct7pm8K57CPitfsA=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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