SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b7c978012843d93716e83a01d960e507e893f8868299bda2c344448a4694f330' 
  AND token = 'XIpObuB8Zg13O6kYWu0E921wnQw9SLM/jSL67GuEo/8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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