SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ab28f1e64f206ef0726575097737f404d84a383a239f9986a3fa494ef735f74c' 
  AND token = 'azqse95MWjRwDeLlLjHBdGGLqRh1IeETn/aVTw0HuJ0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00023

JSON explain

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